Reporte exploratorio de datos

Dataset statistics

Number of variables	52
Number of observations	16947
Missing cells	18150
Missing cells (%)	2.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 MiB
Average record size in memory	223.0 B

Variable types

CAT	32
NUM	9
DATE	6
BOOL	5

Warnings

`Submitted_for_Approval` has constant value "16947"	Constant
`Last_Activity` has constant value "16947"	Constant
`ASP_(converted)_Currency` has constant value "16947"	Constant
`Actual_Delivery_Date` has constant value "16947"	Constant
`Prod_Category_A` has constant value "16947"	Constant
`Territory` has a high cardinality: 76 distinct values	High cardinality
`Billing_Country` has a high cardinality: 80 distinct values	High cardinality
`Account_Name` has a high cardinality: 1635 distinct values	High cardinality
`Opportunity_Name` has a high cardinality: 9841 distinct values	High cardinality
`Opportunity_Owner` has a high cardinality: 53 distinct values	High cardinality
`Price` has a high cardinality: 53 distinct values	High cardinality
`Last_Modified_By` has a high cardinality: 55 distinct values	High cardinality
`Product_Family` has a high cardinality: 227 distinct values	High cardinality
`Product_Name` has a high cardinality: 456 distinct values	High cardinality
`Month` has a high cardinality: 53 distinct values	High cardinality
`Delivery_Year` is highly correlated with `Sales_Contract_No`	High correlation
`Sales_Contract_No` is highly correlated with `Delivery_Year`	High correlation
`Territory` is highly correlated with `Region`	High correlation
`Region` is highly correlated with `Territory` and 3 other fields	High correlation
`Billing_Country` is highly correlated with `Region`	High correlation
`Account_Owner` is highly correlated with `Region`	High correlation
`Opportunity_Owner` is highly correlated with `Region`	High correlation
`Delivery_Quarter` is highly correlated with `Month`	High correlation
`Month` is highly correlated with `Delivery_Quarter`	High correlation
`Total_Amount_Currency` is highly correlated with `ASP_Currency` and 1 other fields	High correlation
`ASP_Currency` is highly correlated with `Total_Amount_Currency` and 1 other fields	High correlation
`Total_Taxable_Amount_Currency` is highly correlated with `ASP_Currency` and 1 other fields	High correlation
`Sales_Contract_No` has 6973 (41.1%) missing values	Missing
`Quote_Expiry_Date` has 4625 (27.3%) missing values	Missing
`ASP` has 3209 (18.9%) missing values	Missing
`ASP_(converted)` has 3209 (18.9%) missing values	Missing
`ASP_(converted)` is highly skewed (γ1 = 80.47407411)	Skewed
`Total_Amount` is highly skewed (γ1 = 42.00442155)	Skewed
`Total_Taxable_Amount` is highly skewed (γ1 = 33.59918963)	Skewed
`ID` has unique values	Unique
`ASP` has 301 (1.8%) zeros	Zeros
`ASP_(converted)` has 300 (1.8%) zeros	Zeros
`TRF` has 11971 (70.6%) zeros	Zeros
`Total_Taxable_Amount` has 997 (5.9%) zeros	Zeros

Reproduction

Analysis started	2020-10-24 14:33:06.555382
Analysis finished	2020-10-24 14:33:39.544073
Duration	32.99 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

ID
Real number (ℝ_≥0)

UNIQUE

Distinct	16947
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17666.65044
Minimum	4854
Maximum	28773
Zeros	0
Zeros (%)	0.0%
Memory size	132.4 KiB

Quantile statistics

Minimum	4854
5-th percentile	6095.3
Q1	11953
median	18114
Q3	23845.5
95-th percentile	27687.4
Maximum	28773
Range	23919
Interquartile range (IQR)	11892.5

Descriptive statistics

Standard deviation	6940.859372
Coefficient of variation (CV)	0.3928791933
Kurtosis	-1.172033787
Mean	17666.65044
Median Absolute Deviation (MAD)	5914
Skewness	-0.1785736993
Sum	299396725
Variance	48175528.83
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
6141	1	< 0.1%
27384	1	< 0.1%
21263	1	< 0.1%
19212	1	< 0.1%
25353	1	< 0.1%
27400	1	< 0.1%
4871	1	< 0.1%
13059	1	< 0.1%
15106	1	< 0.1%
8961	1	< 0.1%
Other values (16937)	16937	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4854	1	< 0.1%
4856	1	< 0.1%
4858	1	< 0.1%
4859	1	< 0.1%
4860	1	< 0.1%

Value	Count	Frequency (%)
28773	1	< 0.1%
28772	1	< 0.1%
28771	1	< 0.1%
28770	1	< 0.1%
28769	1	< 0.1%

Region
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

Japan	4892
EMEA	4664
Americas	3945
APAC	3262
Middle East	184

Frequencies
Length

Value	Count	Frequency (%)
Japan	4892	28.9%
EMEA	4664	27.5%
Americas	3945	23.3%
APAC	3262	19.2%
Middle East	184	1.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	5
Mean length	5.295804567
Min length	4

Territory
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	76
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	19.6 KiB

None	4999
Germany	1682
NW America	1568
Australia	1208
India	809
Other values (71)	6681

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
None	4999	29.5%
Germany	1682	9.9%
NW America	1568	9.3%
Australia	1208	7.1%
India	809	4.8%
NE America	760	4.5%
Japan	681	4.0%
Netherlands	533	3.1%
SE America	493	2.9%
France	449	2.6%
Other values (66)	3765	22.2%

Frequencies of value counts

Unique

Unique	8 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	20
Median length	7
Mean length	7.018646368
Min length	3

Pricing, Delivery_Terms_Quote_Appr
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 KiB

1	13693
0	3254

Common Values
Chart

Value	Count	Frequency (%)
1	13693	80.8%
0	3254	19.2%

Pricing, Delivery_Terms_Approved
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 KiB

1	9890
0	7057

Common Values
Chart

Value	Count	Frequency (%)
1	9890	58.4%
0	7057	41.6%

Bureaucratic_Code_0_Approval
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 KiB

0	8889
1	8058

Common Values
Chart

Value	Count	Frequency (%)
0	8889	52.5%
1	8058	47.5%

Bureaucratic_Code_0_Approved
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 KiB

0	11543
1	5404

Common Values
Chart

Value	Count	Frequency (%)
0	11543	68.1%
1	5404	31.9%

Submitted_for_Approval
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 KiB

0	16947

Common Values
Chart

Value	Count	Frequency (%)
0	16947	100.0%

Bureaucratic_Code
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.9 KiB

Bureaucratic_Code_4	12587
Bureaucratic_Code_5	3803
Bureaucratic_Code_1	261
Bureaucratic_Code_2	242
Bureaucratic_Code_0	51
Other values (2)	3

Frequencies
Length

Value	Count	Frequency (%)
Bureaucratic_Code_4	12587	74.3%
Bureaucratic_Code_5	3803	22.4%
Bureaucratic_Code_1	261	1.5%
Bureaucratic_Code_2	242	1.4%
Bureaucratic_Code_0	51	0.3%
Bureaucratic_Code_3	2	< 0.1%
Bureaucratic_Code_6	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Account_Created_Date
Date

Distinct	809
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

Minimum	2013-07-27 00:00:00
Maximum	2018-12-21 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Source
Categorical

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.3 KiB

None	9497
Source_7	2965
Source_9	1459
Source_11	1421
Source_13	786
Other values (9)	819

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
None	9497	56.0%
Source_7	2965	17.5%
Source_9	1459	8.6%
Source_11	1421	8.4%
Source_13	786	4.6%
Source_3	418	2.5%
Source_1	137	0.8%
Source_10	106	0.6%
Source_2	86	0.5%
Source_4	43	0.3%
Other values (4)	29	0.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	9
Median length	4
Mean length	5.895025668
Min length	4

Billing_Country
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	80
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	19.7 KiB

Japan	4879
United States	3802
Germany	1979
Australia	1169
India	672
Other values (75)	4446

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Japan	4879	28.8%
United States	3802	22.4%
Germany	1979	11.7%
Australia	1169	6.9%
India	672	4.0%
Netherlands	563	3.3%
Singapore	432	2.5%
France	396	2.3%
Spain	317	1.9%
Italy	295	1.7%
Other values (70)	2443	14.4%

Frequencies of value counts

Unique

Unique	15 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	42
Median length	7
Mean length	8.187289786
Min length	4

Account_Name
Categorical

HIGH CARDINALITY

Distinct	1635
Distinct (%)	9.6%
Missing	0
Missing (%)	0.0%
Memory size	125.9 KiB

Account_Name_1888	2124
Account_Name_1836	886
Account_Name_25	752
Account_Name_1991	586
Account_Name_1642	397
Other values (1630)	12202

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Account_Name_1888	2124	12.5%
Account_Name_1836	886	5.2%
Account_Name_25	752	4.4%
Account_Name_1991	586	3.5%
Account_Name_1642	397	2.3%
Account_Name_1508	355	2.1%
Account_Name_1440	317	1.9%
Account_Name_533	283	1.7%
Account_Name_263	249	1.5%
Account_Name_660	231	1.4%
Other values (1625)	10767	63.5%

Frequencies of value counts

Unique

Unique	637 ?
Unique (%)	3.8%

Histogram of lengths of the category

Length

Max length	17
Median length	17
Mean length	16.51560748
Min length	14

Opportunity_Name
Categorical

HIGH CARDINALITY

Distinct	9841
Distinct (%)	58.1%
Missing	0
Missing (%)	0.0%
Memory size	430.0 KiB

Opportunity_Name_9795	36
Opportunity_Name_5036	36
Opportunity_Name_12179	26
Opportunity_Name_11461	26
Opportunity_Name_6835	24
Other values (9836)	16799

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Opportunity_Name_9795	36	0.2%
Opportunity_Name_5036	36	0.2%
Opportunity_Name_12179	26	0.2%
Opportunity_Name_11461	26	0.2%
Opportunity_Name_6835	24	0.1%
Opportunity_Name_1661	18	0.1%
Opportunity_Name_9628	16	0.1%
Opportunity_Name_10946	16	0.1%
Opportunity_Name_10945	16	0.1%
Opportunity_Name_10944	16	0.1%
Other values (9831)	16717	98.6%

Frequencies of value counts

Unique

Unique	6921 ?
Unique (%)	40.8%

Histogram of lengths of the category

Length

Max length	22
Median length	21
Mean length	21.15271139
Min length	18

Opportunity_ID
Real number (ℝ_≥0)

Distinct	9841
Distinct (%)	58.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5335.940225
Minimum	0
Maximum	12803
Zeros	1
Zeros (%)	< 0.1%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	435.3
Q1	2448.5
median	5306
Q3	7698
95-th percentile	11203.5
Maximum	12803
Range	12803
Interquartile range (IQR)	5249.5

Descriptive statistics

Standard deviation	3324.723809
Coefficient of variation (CV)	0.623081157
Kurtosis	-0.7150386945
Mean	5335.940225
Median Absolute Deviation (MAD)	2623
Skewness	0.2852975553
Sum	90428179
Variance	11053788.41
Monotocity	Increasing

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
12460	36	0.2%
2008	36	0.2%
5123	26	0.2%
6606	26	0.2%
2911	24	0.1%
767	18	0.1%
6654	16	0.1%
8698	16	0.1%
6653	16	0.1%
7568	16	0.1%
Other values (9831)	16717	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
12803	1	< 0.1%
12802	1	< 0.1%
12801	3	< 0.1%
12800	2	< 0.1%
12799	1	< 0.1%

Sales_Contract_No
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	5266
Distinct (%)	52.8%
Missing	6973
Missing (%)	41.1%
Infinite	0
Infinite (%)	0.0%

Mean	2725.414979
Minimum	0
Maximum	6517
Zeros	1
Zeros (%)	< 0.1%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	240.65
Q1	1396.5
median	2801.5
Q3	4009
95-th percentile	5203.35
Maximum	6517
Range	6517
Interquartile range (IQR)	2612.5

Descriptive statistics

Standard deviation	1569.252469
Coefficient of variation (CV)	0.5757847818
Kurtosis	-1.132015109
Mean	2725.414979
Median Absolute Deviation (MAD)	1285
Skewness	-0.0416636759
Sum	27183289
Variance	2462553.311
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
108	36	0.2%
479	36	0.2%
2575	18	0.1%
3980	16	0.1%
3876	16	0.1%
3877	16	0.1%
3878	16	0.1%
3123	16	0.1%
5583	16	0.1%
4526	14	0.1%
Other values (5256)	9774	57.7%
(Missing)	6973	41.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	5	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
6517	1	< 0.1%
6516	1	< 0.1%
6515	2	< 0.1%
5593	3	< 0.1%
5590	2	< 0.1%

Account_Owner
Categorical

HIGH CORRELATION

Distinct	48
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	18.2 KiB

Person_Name_50	3730
Person_Name_13	1328
Person_Name_8	1286
Person_Name_43	1241
Person_Name_18	1093
Other values (43)	8269

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Person_Name_50	3730	22.0%
Person_Name_13	1328	7.8%
Person_Name_8	1286	7.6%
Person_Name_43	1241	7.3%
Person_Name_18	1093	6.4%
Person_Name_3	875	5.2%
Person_Name_32	682	4.0%
Person_Name_4	664	3.9%
Person_Name_65	631	3.7%
Person_Name_64	577	3.4%
Other values (38)	4840	28.6%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	14
Mean length	13.80090872
Min length	13

Opportunity_Owner
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	19.5 KiB

Person_Name_50	3781
Person_Name_8	1422
Person_Name_13	1254
Person_Name_18	982
Person_Name_43	838
Other values (48)	8670

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Person_Name_50	3781	22.3%
Person_Name_8	1422	8.4%
Person_Name_13	1254	7.4%
Person_Name_18	982	5.8%
Person_Name_43	838	4.9%
Person_Name_3	832	4.9%
Person_Name_4	687	4.1%
Person_Name_32	686	4.0%
Person_Name_19	615	3.6%
Person_Name_64	516	3.0%
Other values (43)	5334	31.5%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	14
Mean length	13.8094648
Min length	13

Account_Type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.9 KiB

Account_Type_2	8832
Account_Type_0	5868
Account_Type_5	1943
Account_Type_1	165
None	112
Other values (2)	27

Frequencies
Length

Value	Count	Frequency (%)
Account_Type_2	8832	52.1%
Account_Type_0	5868	34.6%
Account_Type_5	1943	11.5%
Account_Type_1	165	1.0%
None	112	0.7%
Account_Type_6	17	0.1%
Account_Type_4	10	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	14
Median length	14
Mean length	13.93391161
Min length	4

Opportunity_Type
Categorical

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.4 KiB

Opportunity_Type_1	6819
Opportunity_Type_7	5763
Opportunity_Type_19	1900
Opportunity_Type_8	1458
Opportunity_Type_12	279
Other values (20)	728

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Opportunity_Type_1	6819	40.2%
Opportunity_Type_7	5763	34.0%
Opportunity_Type_19	1900	11.2%
Opportunity_Type_8	1458	8.6%
Opportunity_Type_12	279	1.6%
Opportunity_Type_3	275	1.6%
Opportunity_Type_20	175	1.0%
Opportunity_Type_2	70	0.4%
Opportunity_Type_4	51	0.3%
Opportunity_Type_10	34	0.2%
Other values (15)	123	0.7%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	19
Median length	18
Mean length	18.14539447
Min length	18

Quote_Type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.6 KiB

Non Binding	16777
Binding	170

Frequencies
Length

Value	Count	Frequency (%)
Non Binding	16777	99.0%
Binding	170	1.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	11
Mean length	10.9598749
Min length	7

Delivery_Terms
Categorical

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.9 KiB

Delivery_Terms_4	7712
Delivery_Terms_2	4633
Delivery_Terms_1	2936
Delivery_Terms_6	781
Delivery_Terms_5	636
Other values (4)	249

Frequencies
Length

Value	Count	Frequency (%)
Delivery_Terms_4	7712	45.5%
Delivery_Terms_2	4633	27.3%
Delivery_Terms_1	2936	17.3%
Delivery_Terms_6	781	4.6%
Delivery_Terms_5	636	3.8%
Delivery_Terms_8	164	1.0%
Delivery_Terms_3	41	0.2%
Delivery_Terms_7	38	0.2%
Delivery_Terms_0	6	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Opportunity_Created_Date
Date

Distinct	1096
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

Minimum	2013-11-05 00:00:00
Maximum	2018-12-29 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Brand
Categorical

Distinct	26
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	18.0 KiB

None	15911
Other	607
Brand_9	140
Brand_5	48
Brand_24	38
Other values (21)	203

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
None	15911	93.9%
Other	607	3.6%
Brand_9	140	0.8%
Brand_5	48	0.3%
Brand_24	38	0.2%
Brand_11	34	0.2%
Brand_25	24	0.1%
Brand_10	22	0.1%
Brand_22	20	0.1%
Brand_7	17	0.1%
Other values (16)	86	0.5%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	8
Median length	4
Mean length	4.12409276
Min length	4

Product_Type
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.9 KiB

None	15935
Other	515
Product_Type_3	179
Product_Type_1	142
Product_Type_0	94
Other values (2)	82

Frequencies
Length

Value	Count	Frequency (%)
None	15935	94.0%
Other	515	3.0%
Product_Type_3	179	1.1%
Product_Type_1	142	0.8%
Product_Type_0	94	0.6%
Product_Type_4	73	0.4%
Product_Type_2	9	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	14
Median length	4
Mean length	4.323656104
Min length	4

Size
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.9 KiB

None	15967
Other	394
Size_3	356
Size_4	196
Size_1	25
Other values (2)	9

Frequencies
Length

Value	Count	Frequency (%)
None	15967	94.2%
Other	394	2.3%
Size_3	356	2.1%
Size_4	196	1.2%
Size_1	25	0.1%
Size_0	7	< 0.1%
Size_2	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	4
Mean length	4.092405736
Min length	4

Product_Category_B
Categorical

Distinct	28
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	18.0 KiB

None	15928
Other	523
Product_Category_B_2	59
Product_Category_B_12	51
Product_Category_B_7	47
Other values (23)	339

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
None	15928	94.0%
Other	523	3.1%
Product_Category_B_2	59	0.3%
Product_Category_B_12	51	0.3%
Product_Category_B_7	47	0.3%
Product_Category_B_4	37	0.2%
Product_Category_B_5	36	0.2%
Product_Category_B_17	27	0.2%
Product_Category_B_1	24	0.1%
Product_Category_B_3	23	0.1%
Other values (18)	192	1.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	21
Median length	4
Mean length	4.512008025
Min length	4

Price
Categorical

HIGH CARDINALITY

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

None	15982
Other	609
0.24	27
0.41	22
0.28	20
Other values (48)	287

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
None	15982	94.3%
Other	609	3.6%
0.24	27	0.2%
0.41	22	0.1%
0.28	20	0.1%
0.27	18	0.1%
0.29	17	0.1%
0.32	15	0.1%
0.38	14	0.1%
0.35	14	0.1%
Other values (43)	209	1.2%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	4
Mean length	4.039062961
Min length	3

Currency
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

None	16052
EUR	475
USD	420

Frequencies
Length

Value	Count	Frequency (%)
None	16052	94.7%
EUR	475	2.8%
USD	420	2.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	3.947188293
Min length	3

Last_Activity
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

NaT	16947

Frequencies
Length

Value	Count	Frequency (%)
NaT	16947	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Quote_Expiry_Date
Date

MISSING

Distinct	1002
Distinct (%)	8.1%
Missing	4625
Missing (%)	27.3%
Memory size	132.4 KiB

Minimum	2014-09-30 00:00:00
Maximum	2019-06-30 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Last_Modified_Date
Date

Distinct	650
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

Minimum	2015-03-12 00:00:00
Maximum	2018-12-29 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Last_Modified_By
Categorical

HIGH CARDINALITY

Distinct	55
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	19.5 KiB

Person_Name_47	8515
Person_Name_50	1210
Person_Name_43	587
Person_Name_13	578
Person_Name_8	511
Other values (50)	5546

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Person_Name_47	8515	50.2%
Person_Name_50	1210	7.1%
Person_Name_43	587	3.5%
Person_Name_13	578	3.4%
Person_Name_8	511	3.0%
Person_Name_18	438	2.6%
Person_Name_33	429	2.5%
Person_Name_19	395	2.3%
Person_Name_3	395	2.3%
Person_Name_4	315	1.9%
Other values (45)	3574	21.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	14
Mean length	13.89809406
Min length	13

Product_Family
Categorical

HIGH CARDINALITY

Distinct	227
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	44.9 KiB

Product_Family_77	1345
Product_Family_133	1249
Product_Family_132	763
Product_Family_212	636
Product_Family_100	619
Other values (222)	12335

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Product_Family_77	1345	7.9%
Product_Family_133	1249	7.4%
Product_Family_132	763	4.5%
Product_Family_212	636	3.8%
Product_Family_100	619	3.7%
Product_Family_85	596	3.5%
Product_Family_115	540	3.2%
Product_Family_226	524	3.1%
Product_Family_109	499	2.9%
Product_Family_208	478	2.8%
Other values (217)	9698	57.2%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	18
Median length	18
Mean length	17.6441258
Min length	16

Product_Name
Categorical

HIGH CARDINALITY

Distinct	456
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	56.7 KiB

Product_Name_100	976
Product_Name_226	836
Product_Name_231	579
Product_Name_491	524
Product_Name_4	474
Other values (451)	13558

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Product_Name_100	976	5.8%
Product_Name_226	836	4.9%
Product_Name_231	579	3.4%
Product_Name_491	524	3.1%
Product_Name_4	474	2.8%
Product_Name_192	442	2.6%
Product_Name_111	388	2.3%
Product_Name_132	383	2.3%
Product_Name_495	350	2.1%
Product_Name_29	345	2.0%
Other values (446)	11650	68.7%

Frequencies of value counts

Unique

Unique	84 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	16
Median length	16
Mean length	15.74609075
Min length	14

ASP_Currency
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

USD	7361
JPY	4522
EUR	4503
AUD	556
GBP	5

Frequencies
Length

Value	Count	Frequency (%)
USD	7361	43.4%
JPY	4522	26.7%
EUR	4503	26.6%
AUD	556	3.3%
GBP	5	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

ASP
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	301
Distinct (%)	2.2%
Missing	3209
Missing (%)	18.9%
Infinite	0
Infinite (%)	0.0%

Mean	7.012128279
Minimum	0
Maximum	80
Zeros	301
Zeros (%)	1.8%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.25
Q1	0.36
median	0.4
Q3	0.505
95-th percentile	59
Maximum	80
Range	80
Interquartile range (IQR)	0.145

Descriptive statistics

Standard deviation	18.85835901
Coefficient of variation (CV)	2.689391617
Kurtosis	5.261237009
Mean	7.012128279
Median Absolute Deviation (MAD)	0.06
Skewness	2.623799882
Sum	96332.6183
Variance	355.6377046
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0.38	801	4.7%
0.4	712	4.2%
0.36	564	3.3%
0.42	510	3.0%
0.39	465	2.7%
0.37	365	2.2%
0	301	1.8%
0.35	295	1.7%
0.34	270	1.6%
0.365	269	1.6%
Other values (291)	9186	54.2%
(Missing)	3209	18.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	301	1.8%
1e-05	1	< 0.1%
0.15	53	0.3%
0.16	8	< 0.1%
0.17	114	0.7%

Value	Count	Frequency (%)
80	14	0.1%
78	86	0.5%
77	12	0.1%
76	6	< 0.1%
75	99	0.6%

ASP_(converted)_Currency
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.6 KiB

USD	16947

Frequencies
Length

Value	Count	Frequency (%)
USD	16947	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

ASP_(converted)
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	441
Distinct (%)	3.2%
Missing	3209
Missing (%)	18.9%
Infinite	0
Infinite (%)	0.0%

Mean	0.4325537043
Minimum	0
Maximum	67
Zeros	300
Zeros (%)	1.8%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.27
Q1	0.37326
median	0.41285
Q3	0.47649
95-th percentile	0.63
Maximum	67
Range	67
Interquartile range (IQR)	0.10323

Descriptive statistics

Standard deviation	0.7586587831
Coefficient of variation (CV)	1.753906568
Kurtosis	6675.953735
Mean	0.4325537043
Median Absolute Deviation (MAD)	0.0509
Skewness	80.47407411
Sum	5942.42279
Variance	0.5755631491
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0.38	570	3.4%
0.4	497	2.9%
0.36	326	1.9%
0.39	325	1.9%
0	300	1.8%
0.42	294	1.7%
0.40719	234	1.4%
0.42982	230	1.4%
0.47506	216	1.3%
0.45244	214	1.3%
Other values (431)	10532	62.1%
(Missing)	3209	18.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	300	1.8%
1e-05	1	< 0.1%
0.00378	1	< 0.1%
0.15	53	0.3%
0.16	8	< 0.1%

Value	Count	Frequency (%)
67	1	< 0.1%
57.68578	1	< 0.1%
1.7	1	< 0.1%
1.6	6	< 0.1%
1	2	< 0.1%

Planned_Delivery_Start_Date
Date

Distinct	986
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

Minimum	2016-01-01 00:00:00
Maximum	2020-09-17 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Planned_Delivery_End_Date
Date

Distinct	1016
Distinct (%)	6.0%
Missing	75
Missing (%)	0.4%
Memory size	132.4 KiB

Minimum	2016-01-05 00:00:00
Maximum	2208-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=20)

Month
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

2018 - 10	666
2017 - 6	643
2017 - 10	638
2016 - 3	628
2017 - 7	625
Other values (48)	13747

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2018 - 10	666	3.9%
2017 - 6	643	3.8%
2017 - 10	638	3.8%
2016 - 3	628	3.7%
2017 - 7	625	3.7%
2017 - 5	586	3.5%
2018 - 4	579	3.4%
2017 - 12	574	3.4%
2018 - 6	542	3.2%
2018 - 7	536	3.2%
Other values (43)	10930	64.5%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	9
Median length	8
Mean length	8.244527055
Min length	8

Delivery_Quarter
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

Q2	4443
Q1	4317
Q4	4144
Q3	4043

Frequencies
Length

Value	Count	Frequency (%)
Q2	4443	26.2%
Q1	4317	25.5%
Q4	4144	24.5%
Q3	4043	23.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Delivery_Year
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2017.137428
Minimum	2016
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Memory size	33.1 KiB

Quantile statistics

Minimum	2016
5-th percentile	2016
Q1	2016
median	2017
Q3	2018
95-th percentile	2018
Maximum	2020
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.8296028156
Coefficient of variation (CV)	0.0004112772902
Kurtosis	-0.9481673267
Mean	2017.137428
Median Absolute Deviation (MAD)	1
Skewness	0.03065373257
Sum	34184428
Variance	0.6882408316
Monotocity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
2017	6318	37.3%
2018	5830	34.4%
2016	4371	25.8%
2019	414	2.4%
2020	14	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2016	4371	25.8%
2017	6318	37.3%
2018	5830	34.4%
2019	414	2.4%
2020	14	0.1%

Value	Count	Frequency (%)
2020	14	0.1%
2019	414	2.4%
2018	5830	34.4%
2017	6318	37.3%
2016	4371	25.8%

Actual_Delivery_Date
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

NaT	16947

Frequencies
Length

Value	Count	Frequency (%)
NaT	16947	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

TRF
Real number (ℝ_≥0)

ZEROS

Distinct	101
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.338171948
Minimum	0
Maximum	500
Zeros	11971
Zeros (%)	70.6%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	10
Maximum	500
Range	500
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	12.16933936
Coefficient of variation (CV)	5.204638339
Kurtosis	468.696877
Mean	2.338171948
Median Absolute Deviation (MAD)	0
Skewness	17.060823
Sum	39625
Variance	148.0928205
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	11971	70.6%
1	2192	12.9%
2	627	3.7%
3	354	2.1%
5	297	1.8%
4	208	1.2%
10	190	1.1%
6	131	0.8%
7	111	0.7%
20	83	0.5%
Other values (91)	783	4.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11971	70.6%
1	2192	12.9%
2	627	3.7%
3	354	2.1%
4	208	1.2%

Value	Count	Frequency (%)
500	1	< 0.1%
429	1	< 0.1%
400	2	< 0.1%
270	1	< 0.1%
250	1	< 0.1%

Total_Amount_Currency
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

USD	7361
JPY	4522
EUR	4503
AUD	556
GBP	5

Frequencies
Length

Value	Count	Frequency (%)
USD	7361	43.4%
JPY	4522	26.7%
EUR	4503	26.6%
AUD	556	3.3%
GBP	5	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Total_Amount
Real number (ℝ_≥0)

SKEWED

Distinct	8872
Distinct (%)	52.5%
Missing	59
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	1993659.215
Minimum	0
Maximum	1320000000
Zeros	52
Zeros (%)	0.3%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2900
Q1	26775
median	107250
Q3	460389.825
95-th percentile	7010372.365
Maximum	1320000000
Range	1320000000
Interquartile range (IQR)	433614.825

Descriptive statistics

Standard deviation	18484259.88
Coefficient of variation (CV)	9.271524312
Kurtosis	2322.422807
Mean	1993659.215
Median Absolute Deviation (MAD)	101050
Skewness	42.00442155
Sum	3.366891683e+10
Variance	3.416678634e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
6200	513	3.0%
4400	461	2.7%
18000	353	2.1%
140000	272	1.6%
1600	204	1.2%
160000	132	0.8%
109620	100	0.6%
23400	80	0.5%
85260	75	0.4%
81200	75	0.4%
Other values (8862)	14623	86.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	52	0.3%
0.01	7	< 0.1%
0.02	3	< 0.1%
0.04	1	< 0.1%
0.1	1	< 0.1%

Value	Count	Frequency (%)
1320000000	1	< 0.1%
919992410	1	< 0.1%
760000000	1	< 0.1%
660005280	1	< 0.1%
660004620	1	< 0.1%

Total_Taxable_Amount_Currency
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

USD	7347
JPY	4525
EUR	4518
AUD	553
GBP	4

Frequencies
Length

Value	Count	Frequency (%)
USD	7347	43.4%
JPY	4525	26.7%
EUR	4518	26.7%
AUD	553	3.3%
GBP	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Total_Taxable_Amount
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	7096
Distinct (%)	41.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3224116.789
Minimum	0
Maximum	1356338620
Zeros	997
Zeros (%)	5.9%
Memory size	132.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	85465.8
median	376067.25
Q3	1037450
95-th percentile	12770625
Maximum	1356338620
Range	1356338620
Interquartile range (IQR)	951984.2

Descriptive statistics

Standard deviation	20303604.73
Coefficient of variation (CV)	6.297416022
Kurtosis	1706.197108
Mean	3224116.789
Median Absolute Deviation (MAD)	310517.25
Skewness	33.59918963
Sum	5.463910723e+10
Variance	4.122363649e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	997	5.9%
588325	72	0.4%
109620	68	0.4%
488700	66	0.4%
413700	60	0.4%
552400	60	0.4%
1767640	48	0.3%
523100	40	0.2%
105840	37	0.2%
31053609.6	36	0.2%
Other values (7086)	15463	91.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	997	5.9%
0.15	1	< 0.1%
45	1	< 0.1%
100.1	1	< 0.1%
101.4	2	< 0.1%

Value	Count	Frequency (%)
1356338620	1	< 0.1%
919992410	1	< 0.1%
760000000	1	< 0.1%
660005280	1	< 0.1%
660004620	1	< 0.1%

Stage
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.7 KiB

Closed Won	9533
Closed Lost	7350
Proposal	35
Negotiation	18
Qualification	11

Frequencies
Length

Value	Count	Frequency (%)
Closed Won	9533	56.3%
Closed Lost	7350	43.4%
Proposal	35	0.2%
Negotiation	18	0.1%
Qualification	11	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	10
Mean length	10.43258394
Min length	8

Prod_Category_A
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	132.4 KiB

Prod_Category_A_None	16947

Frequencies
Length

Value	Count	Frequency (%)
Prod_Category_A_None	16947	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	20
Median length	20
Mean length	20
Min length	20

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	ID	Region	Territory	Pricing, Delivery_Terms_Quote_Appr	Pricing, Delivery_Terms_Approved	Bureaucratic_Code_0_Approval	Bureaucratic_Code_0_Approved	Bureaucratic_Code	Account_Created_Date	Source	Billing_Country	Account_Name	Opportunity_Name	Opportunity_ID	Sales_Contract_No	Account_Owner	Opportunity_Owner	Account_Type	Opportunity_Type	Quote_Type	Delivery_Terms	Opportunity_Created_Date	Brand	Product_Type	Size	Product_Category_B	Price	Currency	Last_Activity	Quote_Expiry_Date	Last_Modified_Date	Last_Modified_By	Product_Family	Product_Name	ASP_Currency	ASP	ASP_(converted)_Currency	ASP_(converted)	Planned_Delivery_Start_Date	Planned_Delivery_End_Date	Month	Delivery_Quarter	Delivery_Year	Actual_Delivery_Date	TRF	Total_Amount_Currency	Total_Amount	Total_Taxable_Amount_Currency	Total_Taxable_Amount	Stage	Prod_Category_A
0	27761	EMEA	None	1	1	1	1	Bureaucratic_Code_4	2015-06-16	None	Netherlands	Account_Name_619	Opportunity_Name_12598	0	nan	Person_Name_51	Person_Name_18	Account_Type_2	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-07	None	None	None	None	None	None	NaT	2016-01-30	2016-06-13	Person_Name_18	Product_Family_77	Product_Name_99	EUR	0.52	USD	0.59	2016-05-01	2016-06-30	2016 - 5	Q2	2016	NaT	10	EUR	5,272,800.00	EUR	5,272,800.00	Closed Lost	Prod_Category_A_None
1	27760	EMEA	None	0	0	0	0	Bureaucratic_Code_4	2015-06-16	None	Netherlands	Account_Name_619	Opportunity_Name_12600	1	39.00	Person_Name_51	Person_Name_20	Account_Type_2	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-07	None	None	None	None	None	None	NaT	2016-01-20	2016-01-15	Person_Name_20	Product_Family_77	Product_Name_100	EUR	0.53	USD	0.60	2016-01-18	2016-01-20	2016 - 1	Q1	2016	NaT	0	EUR	48,230.00	EUR	48,230.00	Closed Won	Prod_Category_A_None
2	27446	Americas	NW America	0	0	0	0	Bureaucratic_Code_4	2015-04-21	Source_7	United States	Account_Name_1794	Opportunity_Name_469	2	760.00	Person_Name_64	Person_Name_8	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_4	2015-12-08	None	None	None	None	None	None	NaT	2016-09-30	2016-09-29	Person_Name_8	Product_Family_81	Product_Name_91	USD	0.48	USD	0.48	2016-01-25	2016-01-25	2016 - 1	Q1	2016	NaT	0	USD	83,865.60	USD	83,865.60	Closed Won	Prod_Category_A_None
3	16808	Americas	NW America	1	0	1	0	Bureaucratic_Code_5	2013-07-27	Source_11	United States	Account_Name_1201	Opportunity_Name_415	3	nan	Person_Name_8	Person_Name_8	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_1	2015-12-08	Other	Product_Type_0	Size_4	Product_Category_B_16	0.42	USD	NaT	NaT	2018-03-27	Person_Name_8	Product_Family_209	Product_Name_432	USD	0.53	USD	0.53	2018-02-01	2018-03-31	2018 - 2	Q1	2018	NaT	14	USD	7,421,881.50	USD	7,421,881.50	Closed Lost	Prod_Category_A_None
4	16805	Americas	NW America	1	0	1	0	Bureaucratic_Code_5	2013-07-27	Source_11	United States	Account_Name_1201	Opportunity_Name_851	4	nan	Person_Name_8	Person_Name_8	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_1	2015-12-08	Other	Product_Type_0	Size_4	Product_Category_B_16	0.42	USD	NaT	2017-06-02	2018-03-27	Person_Name_8	Product_Family_209	Product_Name_432	USD	0.53	USD	0.53	2018-02-01	2018-02-28	2018 - 2	Q1	2018	NaT	25	USD	13,357,192.50	USD	13,357,192.50	Closed Lost	Prod_Category_A_None
5	16802	Americas	NW America	1	0	1	0	Bureaucratic_Code_5	2013-07-27	Source_11	United States	Account_Name_1201	Opportunity_Name_939	5	nan	Person_Name_8	Person_Name_8	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_1	2015-12-08	Other	Product_Type_0	Size_4	Product_Category_B_16	0.42	USD	NaT	2017-06-02	2018-03-27	Person_Name_8	Product_Family_209	Product_Name_432	USD	0.53	USD	0.53	2018-02-01	2018-03-31	2018 - 2	Q1	2018	NaT	28	USD	14,838,277.50	USD	14,838,277.50	Closed Lost	Prod_Category_A_None
6	16799	Americas	NW America	1	0	1	0	Bureaucratic_Code_5	2013-07-27	Source_11	United States	Account_Name_1201	Opportunity_Name_1618	6	nan	Person_Name_8	Person_Name_8	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_4	2015-12-08	None	None	None	None	None	None	NaT	NaT	2016-10-07	Person_Name_8	Product_Family_164	Product_Name_308	USD	0.38	USD	0.38	2017-02-01	2017-05-01	2017 - 2	Q1	2017	NaT	7	USD	2,659,494.60	USD	2,659,494.60	Closed Lost	Prod_Category_A_None
7	27455	Americas	NW America	1	1	1	1	Bureaucratic_Code_4	2015-04-21	Source_7	United States	Account_Name_1794	Opportunity_Name_8227	7	nan	Person_Name_64	Person_Name_8	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_4	2015-12-09	None	None	None	None	None	None	NaT	2016-01-07	2015-12-09	Person_Name_8	Product_Family_143	Product_Name_251	USD	0.48	USD	0.48	2016-01-25	2016-01-25	2016 - 1	Q1	2016	NaT	0	USD	50,688.00	USD	50,688.00	Closed Won	Prod_Category_A_None
8	24353	Japan	None	1	0	0	0	Bureaucratic_Code_5	2015-04-20	None	Japan	Account_Name_1888	Opportunity_Name_6151	8	nan	Person_Name_50	Person_Name_50	Account_Type_2	Opportunity_Type_7	Non Binding	Delivery_Terms_4	2015-12-09	None	None	None	None	None	None	NaT	NaT	2016-04-05	Person_Name_50	Product_Family_6	Product_Name_6	JPY	nan	USD	nan	2016-02-29	2016-02-29	2016 - 2	Q1	2016	NaT	0	JPY	15,600.00	JPY	470,400.00	Closed Lost	Prod_Category_A_None
9	24355	Japan	None	1	0	0	0	Bureaucratic_Code_5	2015-04-20	None	Japan	Account_Name_1888	Opportunity_Name_6151	8	nan	Person_Name_50	Person_Name_50	Account_Type_2	Opportunity_Type_7	Non Binding	Delivery_Terms_4	2015-12-09	None	None	None	None	None	None	NaT	NaT	2016-04-05	Person_Name_50	Product_Family_4	Product_Name_4	JPY	nan	USD	nan	2016-02-29	2016-02-29	2016 - 2	Q1	2016	NaT	0	JPY	4,400.00	JPY	470,400.00	Closed Lost	Prod_Category_A_None

Last rows

	ID	Region	Territory	Pricing, Delivery_Terms_Quote_Appr	Pricing, Delivery_Terms_Approved	Bureaucratic_Code_0_Approval	Bureaucratic_Code_0_Approved	Bureaucratic_Code	Account_Created_Date	Source	Billing_Country	Account_Name	Opportunity_Name	Opportunity_ID	Sales_Contract_No	Account_Owner	Opportunity_Owner	Account_Type	Opportunity_Type	Quote_Type	Delivery_Terms	Opportunity_Created_Date	Brand	Product_Type	Size	Product_Category_B	Price	Currency	Last_Activity	Quote_Expiry_Date	Last_Modified_Date	Last_Modified_By	Product_Family	Product_Name	ASP_Currency	ASP	ASP_(converted)_Currency	ASP_(converted)	Planned_Delivery_Start_Date	Planned_Delivery_End_Date	Month	Delivery_Quarter	Delivery_Year	Actual_Delivery_Date	TRF	Total_Amount_Currency	Total_Amount	Total_Taxable_Amount_Currency	Total_Taxable_Amount	Stage	Prod_Category_A
16937	17683	EMEA	Germany	0	0	0	0	Bureaucratic_Code_4	2013-07-27	Source_9	Germany	Account_Name_533	Opportunity_Name_4060	12797	nan	Person_Name_13	Person_Name_13	Account_Type_0	Opportunity_Type_8	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	2016-01-03	2015-12-18	Person_Name_13	Product_Family_77	Product_Name_96	EUR	0.53	USD	0.60	2016-02-01	2016-02-29	2016 - 2	Q1	2016	NaT	1	EUR	413,400.00	EUR	528,918.75	Closed Won	Prod_Category_A_None
16938	28767	EMEA	Germany	1	0	0	0	Bureaucratic_Code_5	2015-12-04	None	Germany	Account_Name_586	Opportunity_Name_5088	12798	nan	Person_Name_13	Person_Name_13	Account_Type_2	Opportunity_Type_19	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	2016-02-05	2016-10-21	Person_Name_13	Product_Family_85	Product_Name_110	EUR	0.47	USD	0.53	2016-08-15	2016-09-30	2016 - 8	Q3	2016	NaT	3	EUR	1,307,775.00	EUR	1,307,775.00	Closed Lost	Prod_Category_A_None
16939	18324	EMEA	Norway	1	1	0	0	Bureaucratic_Code_4	2013-07-27	Source_9	Germany	Account_Name_533	Opportunity_Name_7202	12799	224.00	Person_Name_13	Person_Name_13	Account_Type_0	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	2016-04-03	2016-04-01	Person_Name_13	Product_Family_77	Product_Name_96	EUR	0.52	USD	0.58	2016-04-01	2016-04-21	2016 - 4	Q2	2016	NaT	1	EUR	401,700.00	EUR	401,700.00	Closed Won	Prod_Category_A_None
16940	20827	Americas	NE America	1	0	0	0	Bureaucratic_Code_5	2014-06-16	None	Germany	Account_Name_404	Opportunity_Name_11979	12800	nan	Person_Name_13	Person_Name_13	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_4	2015-12-04	None	None	None	None	None	None	NaT	2016-01-15	2016-10-10	Person_Name_13	Product_Family_164	Product_Name_307	USD	0.53	USD	0.53	2016-10-03	2016-12-30	2016 - 10	Q4	2016	NaT	20	USD	10,751,580.00	USD	21,332,500.00	Closed Lost	Prod_Category_A_None
16941	20830	Americas	NE America	1	0	0	0	Bureaucratic_Code_5	2014-06-16	None	Germany	Account_Name_404	Opportunity_Name_11979	12800	nan	Person_Name_13	Person_Name_13	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_4	2015-12-04	None	None	None	None	None	None	NaT	2016-01-15	2016-10-10	Person_Name_13	Product_Family_158	Product_Name_286	USD	0.53	USD	0.53	2016-10-03	2016-12-30	2016 - 10	Q4	2016	NaT	20	USD	10,580,920.00	USD	21,332,500.00	Closed Lost	Prod_Category_A_None
16942	8781	EMEA	Austria	1	1	1	1	Bureaucratic_Code_4	2016-01-15	Source_7	Austria	Account_Name_726	Opportunity_Name_9245	12801	44.00	Person_Name_13	Person_Name_13	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	NaT	2016-01-19	Person_Name_13	Product_Family_85	Product_Name_111	EUR	0.52	USD	0.59	2016-03-21	2016-03-25	2016 - 3	Q1	2016	NaT	0	EUR	103,350.00	EUR	299,715.00	Closed Won	Prod_Category_A_None
16943	8786	EMEA	Austria	1	1	1	1	Bureaucratic_Code_4	2016-01-15	Source_7	Austria	Account_Name_726	Opportunity_Name_9245	12801	44.00	Person_Name_13	Person_Name_13	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	NaT	2016-01-19	Person_Name_13	Product_Family_85	Product_Name_111	EUR	0.52	USD	0.59	2016-04-04	2016-04-08	2016 - 4	Q2	2016	NaT	0	EUR	93,015.00	EUR	299,715.00	Closed Won	Prod_Category_A_None
16944	8792	EMEA	Austria	1	1	1	1	Bureaucratic_Code_4	2016-01-15	Source_7	Austria	Account_Name_726	Opportunity_Name_9245	12801	44.00	Person_Name_13	Person_Name_13	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_2	2015-12-04	None	None	None	None	None	None	NaT	NaT	2016-01-19	Person_Name_13	Product_Family_85	Product_Name_111	EUR	0.52	USD	0.59	2016-03-28	2016-03-31	2016 - 3	Q1	2016	NaT	0	EUR	103,350.00	EUR	299,715.00	Closed Won	Prod_Category_A_None
16945	28561	Americas	NE America	1	1	1	1	Bureaucratic_Code_4	2015-10-20	None	United States	Account_Name_944	Opportunity_Name_5843	12802	nan	Person_Name_3	Person_Name_3	Account_Type_5	Opportunity_Type_1	Non Binding	Delivery_Terms_4	2015-12-05	None	None	None	None	None	None	NaT	2016-02-29	2016-01-22	Person_Name_3	Product_Family_158	Product_Name_287	USD	0.64	USD	0.64	2016-04-25	2016-04-29	2016 - 4	Q2	2016	NaT	4	USD	2,346,796.88	USD	0.00	Closed Lost	Prod_Category_A_None
16946	28318	Americas	NE America	1	1	1	1	Bureaucratic_Code_4	2015-09-03	None	United States	Account_Name_1401	Opportunity_Name_9911	12803	nan	Person_Name_3	Person_Name_3	Account_Type_5	Opportunity_Type_19	Non Binding	Delivery_Terms_4	2015-12-05	None	None	None	None	None	None	NaT	2016-01-06	2016-09-28	Person_Name_3	Product_Family_164	Product_Name_307	USD	0.64	USD	0.64	2016-07-01	2016-08-31	2016 - 7	Q3	2016	NaT	40	USD	25,603,200.00	USD	0.00	Closed Lost	Prod_Category_A_None

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows